Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / ParseFormula(String,Int32,Int32,Nullable<Boolean>,Boolean) Method
A string value indicates the formula text.
An integer value indicates the context row index.
An integer value indicates the context column index.
true if the +/- may be removed automatically.


In This Topic
    ParseFormula(String,Int32,Int32,Nullable<Boolean>,Boolean) Method
    In This Topic
    Parses the specified formula to expression.
    Syntax
    'Declaration
     
    
    Public Function ParseFormula( _
       ByVal formula As String, _
       Optional ByVal contextRow As Integer, _
       Optional ByVal contextColumn As Integer, _
       Optional ByVal isA1Reference As Nullable(Of Boolean), _
       Optional ByVal detectFormulaSymbol As Boolean _
    ) As Expression
    'Usage
     
    
    Dim instance As Worksheet
    Dim formula As String
    Dim contextRow As Integer
    Dim contextColumn As Integer
    Dim isA1Reference As Nullable(Of Boolean)
    Dim detectFormulaSymbol As Boolean
    Dim value As Expression
     
    value = instance.ParseFormula(formula, contextRow, contextColumn, isA1Reference, detectFormulaSymbol)

    Parameters

    formula
    A string value indicates the formula text.
    contextRow
    An integer value indicates the context row index.
    contextColumn
    An integer value indicates the context column index.
    isA1Reference
    detectFormulaSymbol
    true if the +/- may be removed automatically.

    Return Value

    A GrapeCity.CalcEngine.Expression value represents the parsed expression.
    See Also